UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vt8TTPiyxyIlHBNhiwJ3lqOaZplE2dzMoPHjhVjCutQ='
WHERE
key_id = '1a207757968e3e27e4df51bb011be239976845a01489332e65a8112c54413d5e'
AND (
token = 'vt8TTPiyxyIlHBNhiwJ3lqOaZplE2dzMoPHjhVjCutQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)