UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '0kv1dCmxth6Z4Yr1Pa54Mzj01Xe6wM/8BGapWQiHkoM=' 
WHERE 
  key_id = '9d64c97aea84567250d12f40c9e7a9d591997309d5e53bfdeb7e06fc909bb06e' 
  AND (
    token = '0kv1dCmxth6Z4Yr1Pa54Mzj01Xe6wM/8BGapWQiHkoM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025