UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ie+GH+Qh/wXC1MiGh3jx+0Nf377t6vb/oGpgT395GqE=' 
WHERE 
  key_id = 'aa0bf76afbcd560c1096d3fc90c58fd669c5191404c4c83b7e7db86f583a1460' 
  AND (
    token = 'ie+GH+Qh/wXC1MiGh3jx+0Nf377t6vb/oGpgT395GqE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023