UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'S0db1e/KH6ukdHNKY/E6oSWq/n4Vp9l8HRcrTE8Ifa8=' 
WHERE 
  key_id = '917baa1cd7fed6bc7099b56ad3d34a70dc4133b01aabc3af20984bc0f5aec216' 
  AND (
    token = 'S0db1e/KH6ukdHNKY/E6oSWq/n4Vp9l8HRcrTE8Ifa8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024