UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fq4W9RDZGLjNflcLlzcV+QPqLXLjXUm1Gb/Ig6egDGM='
WHERE
key_id = '06dc0bb3551cff80ec28709821f4030180d996ed522483ac437f5d292327d66f'
AND (
token = 'fq4W9RDZGLjNflcLlzcV+QPqLXLjXUm1Gb/Ig6egDGM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)