UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'EdJn94jA1/tmg7lISJZ3KPnCTAsyqWOdEUHq5wjJ3F8=' 
WHERE 
  key_id = 'e55172bc08713e05a7a7030905ec993767110b4bbc2c39065b3b3e179b6dbce9' 
  AND (
    token = 'EdJn94jA1/tmg7lISJZ3KPnCTAsyqWOdEUHq5wjJ3F8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042