UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nNn5ydQZB6XjkX8Feu684QGolIITg57LI8fvfOL/3bo='
WHERE
key_id = '94df336152487d6bd3664d1e417d3b71c9f47c2b164cfd86efb54ae31627b51a'
AND (
token = 'nNn5ydQZB6XjkX8Feu684QGolIITg57LI8fvfOL/3bo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)