UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'n4IVLEAcn85VYJBvwkX2eGaLdoQAI9NbX5vIZjj0IeE=' 
WHERE 
  key_id = '28d3c3392e08df6c768c1e3c8a1ddd5e1cf93312b3c035904cf8727daf3b82d6' 
  AND (
    token = 'n4IVLEAcn85VYJBvwkX2eGaLdoQAI9NbX5vIZjj0IeE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024