UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'aQl9iXsabCFg1gHYK4Dkn7r7Y8YbwCTyMuDGveAtMzM=' 
WHERE 
  key_id = 'dee2f64f12ab87d4a7d667f343b7abf9dc2ab2fefd4119f8a2261fbf1387419b' 
  AND (
    token = 'aQl9iXsabCFg1gHYK4Dkn7r7Y8YbwCTyMuDGveAtMzM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026