UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nv7ogXhvfLCb51qDMI3aFvg1C7Q1h2BrIdQGfCIyENk='
WHERE
key_id = '478ddf8f79d0ad324cb5bcf2b6daa1baa43bbb604c244730392534358d7c0d2f'
AND (
token = 'nv7ogXhvfLCb51qDMI3aFvg1C7Q1h2BrIdQGfCIyENk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)