UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qyfBQUqa366yM+o4IoxQXG/sCDIyqGeG+OC7troQFy8='
WHERE
key_id = '6f1f55063add22acdaf8c383185b52521d2211e230a136ed64166b8813787f18'
AND (
token = 'qyfBQUqa366yM+o4IoxQXG/sCDIyqGeG+OC7troQFy8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)