UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R0flmlif26aiiLvJ4a71R2fw2uY8qZ54p3kP0kUJwxw='
WHERE
key_id = 'bee863ca4cfc785fb52e9cb0042bb472361814370c460701fd568268e8c5b894'
AND (
token = 'R0flmlif26aiiLvJ4a71R2fw2uY8qZ54p3kP0kUJwxw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)