UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'XEBsfPSLWXsNGc1R5+EJnVWJG2b0C2piE85VBKbWA8U=' 
WHERE 
  key_id = 'd2e7c534ddbdf010e61002c32668551deb7ba8dc1dd50aa28c94c8898f0d37a9' 
  AND (
    token = 'XEBsfPSLWXsNGc1R5+EJnVWJG2b0C2piE85VBKbWA8U=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033