UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'RYrHB07tUJ4L8ktRMr5qw7JDzn/lYvtC4oQNqOMzEqo=' 
WHERE 
  key_id = '695d9cdd42e33fcc55c5a9044a6bc2ff6560be0da8cc84a873cea40158d7cd48' 
  AND (
    token = 'RYrHB07tUJ4L8ktRMr5qw7JDzn/lYvtC4oQNqOMzEqo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020