UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xJ4MFfkNqrt8qLcocnPbDslLs1M6eJgW+L+lQnEWXao=' 
WHERE 
  key_id = '8c49b0e62f115913e257d0abd995aa163eb7b2673fc532e2f1a5bb3678d5a4a4' 
  AND (
    token = 'xJ4MFfkNqrt8qLcocnPbDslLs1M6eJgW+L+lQnEWXao=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030