UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'of+DMcg0WJ9U2tKdPAxpJWVUS6tNavjWXm9S/Bm7nts=' 
WHERE 
  key_id = 'e94ba67f1b1e3ceea20eef275fba56ddc1e0cb37f6be9060e306778ec21da8ca' 
  AND (
    token = 'of+DMcg0WJ9U2tKdPAxpJWVUS6tNavjWXm9S/Bm7nts=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020