UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'J+3D+RKdnk+7WDD4/ZjqWbJPkVY0BKZ2NZCvB0USFbk=' 
WHERE 
  key_id = '3ce59c36b55a3639d8524b86094dbf6f693ef99c85d3cfb4d5256ebba9e313a7' 
  AND (
    token = 'J+3D+RKdnk+7WDD4/ZjqWbJPkVY0BKZ2NZCvB0USFbk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00049