UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BHm80h4t6fGNlikEFgdGJuCaEsOZQFYvo3cHlqkmZTU='
WHERE
key_id = '0ea511c5b9a834ffc3ceddc5c77811a8e20a3382649f88e8c8eb1801b2eaff03'
AND (
token = 'BHm80h4t6fGNlikEFgdGJuCaEsOZQFYvo3cHlqkmZTU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)