UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X2hOqxWzcPEbghRxX+Tg7fsdYX9Y4QwXuIMTR6xP394='
WHERE
key_id = '1a226a05f44a17b51eac8d09684debd69f4ce0717bec8971cddf191f8598cb2f'
AND (
token = 'X2hOqxWzcPEbghRxX+Tg7fsdYX9Y4QwXuIMTR6xP394='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)