UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'MyN/oa8D6chpUsHnZv72BhEq+tMpTykYPxGA9Pvph0M=' 
WHERE 
  key_id = '6a2d4ea28122ebdb6d4b75ff6beedbf4e9a42dfef48c9ce5623e6cddc2182dae' 
  AND (
    token = 'MyN/oa8D6chpUsHnZv72BhEq+tMpTykYPxGA9Pvph0M=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043