UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'wNsxf6qu8oPCF8bDHpX4fjEMtxlkntz0mvv0VuNqpWo=' 
WHERE 
  key_id = '3c9176933b87d63c9e00b653eeaea8a77f67f0d5a5d6799d2825d99df7698aac' 
  AND (
    token = 'wNsxf6qu8oPCF8bDHpX4fjEMtxlkntz0mvv0VuNqpWo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027