UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zfPYYv/4Jpu9FHvYLTZMObPUqbp5UtnPuoGOD+aoMJg='
WHERE
key_id = '8d2e8b2c5816c0c4eed9dccde23c10a98773bbfa0698386ec6030def845c26f0'
AND (
token = 'zfPYYv/4Jpu9FHvYLTZMObPUqbp5UtnPuoGOD+aoMJg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)