UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4ukzKu30Qxv+PV+MsGe/rv1N0gcmKIb7VPFly6Jg/fE=' 
WHERE 
  key_id = '71f76690e1815bac39958113f17be6950bb9fe53f2580717e89476eb8f364963' 
  AND (
    token = '4ukzKu30Qxv+PV+MsGe/rv1N0gcmKIb7VPFly6Jg/fE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031