UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ppS3/xqFd9Im5pjhoTqDgkVO2L7lwn4uQFtA5Xb8QJA=' 
WHERE 
  key_id = 'c9d747445b468a55da114ec1d4abeb2967f80e32cd42b4f81a58a03b90b1e51e' 
  AND (
    token = 'ppS3/xqFd9Im5pjhoTqDgkVO2L7lwn4uQFtA5Xb8QJA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00039