UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Un4cWr91EG5fMIOxXK0cTKVVL4kOsogl5o/J77wO5DM='
WHERE
key_id = 'b36944cd9fe46b1ab5474425c11b744ac50928a33b65b08556ef01065ac4c47a'
AND (
token = 'Un4cWr91EG5fMIOxXK0cTKVVL4kOsogl5o/J77wO5DM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)