UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'e5yDnUIV24pbEpDnHd5alOl5/8ucMFKfuN5IBsZ7yTs=' 
WHERE 
  key_id = 'fa9bee55ac67d2ec2e749a569fbba4f26f522fb27907eabfeae58bf7aa409b26' 
  AND (
    token = 'e5yDnUIV24pbEpDnHd5alOl5/8ucMFKfuN5IBsZ7yTs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00057