UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '6iJM6bIFs/VJ30rRP1e4fhoccY8mw60CYtHS2QRe+Vg=' 
WHERE 
  key_id = '897778f7ea3b471a56fea9df235e368531c5fa72bb44713b4bc22eb9abf2d8e7' 
  AND (
    token = '6iJM6bIFs/VJ30rRP1e4fhoccY8mw60CYtHS2QRe+Vg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035