UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'zjX4KDAn3joicKJOEVXxKAucfn75JdfdE5pA8t9qYbs=' 
WHERE 
  key_id = '788167364262e7b2b19cc7ac0bf03f31adfd6b914657a7c414bf312830c9e4c7' 
  AND (
    token = 'zjX4KDAn3joicKJOEVXxKAucfn75JdfdE5pA8t9qYbs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032