UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'zkI36hKCeb0nm9S7kB0/Do/d/U2EV7nNga7MknuVzYI=' 
WHERE 
  key_id = '9b202b554bc32bc04c3a0275b88d3b9f38944d05457ef126177c1e9ae1f72eb7' 
  AND (
    token = 'zkI36hKCeb0nm9S7kB0/Do/d/U2EV7nNga7MknuVzYI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045