UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hwCQtJhUWfNJbJqvbUwEOaDKhRj07ja+8kGdgW0YZzU='
WHERE
key_id = '31f19758e85dbce8bd3bdd5e95300fb20ca1111e0cb6d691c1534d7716b27335'
AND (
token = 'hwCQtJhUWfNJbJqvbUwEOaDKhRj07ja+8kGdgW0YZzU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)