UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MrHwZtlA5jOe2BJoxAUqSg3PSnQtALQ2WiOSf4opxgM='
WHERE
key_id = '9b14aabd538a68d6a469078c00aaeb7b6ac0dbd6a7c3d1ad378ad31ba1bce573'
AND (
token = 'MrHwZtlA5jOe2BJoxAUqSg3PSnQtALQ2WiOSf4opxgM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)