UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'JFvJQM4Qs6OFuoQjw9Z/vQdpwhWpi7kLmT5pxN3p5vQ=' 
WHERE 
  key_id = '522314e0923af4b72f34f99bff1325161e875c3fbd9b7c5de4acdcd5bfb12974' 
  AND (
    token = 'JFvJQM4Qs6OFuoQjw9Z/vQdpwhWpi7kLmT5pxN3p5vQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021