UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8pewCfKU6dfmYK4uJCN2Caf5o9VC5FKqTrtehin3irM=' 
WHERE 
  key_id = '0684339ab6c18631a3613ba3b0f9ac6c5cc3e8bd0ecb34827bf69a389b87df33' 
  AND (
    token = '8pewCfKU6dfmYK4uJCN2Caf5o9VC5FKqTrtehin3irM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033