UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nMQh6TKOmmCOVFxNnfXwxjfQ9dbIM3pcKv0Um7lfKn8='
WHERE
key_id = 'd1a68cbcb0b33d109ef5d6bc3215a7248859684c931640d59702675be0b17b31'
AND (
token = 'nMQh6TKOmmCOVFxNnfXwxjfQ9dbIM3pcKv0Um7lfKn8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)