UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uum+fS6iS1cM+cVbOyVZrarxQdmsiAb1pXQMsElI0S8='
WHERE
key_id = '45a261984913f15825768270272322268a702991c7419bd2193d4e9c32228f7b'
AND (
token = 'uum+fS6iS1cM+cVbOyVZrarxQdmsiAb1pXQMsElI0S8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)