UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'QcJK7sd+AZoa2IfU77lD1oPP9BxrWAI1S/xqCHK55C8=' 
WHERE 
  key_id = 'd4fbff1cf82e979f61c590f88a8f52285afc17fce480a9f56eadba705f49fc4e' 
  AND (
    token = 'QcJK7sd+AZoa2IfU77lD1oPP9BxrWAI1S/xqCHK55C8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00046